package com.zhongwang.mms.gen.entity;

import java.util.ArrayList;
import java.util.List;

public class MMaterialsExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public MMaterialsExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andMatIdIsNull() {
            addCriterion("mat_id is null");
            return (Criteria) this;
        }

        public Criteria andMatIdIsNotNull() {
            addCriterion("mat_id is not null");
            return (Criteria) this;
        }

        public Criteria andMatIdEqualTo(Integer value) {
            addCriterion("mat_id =", value, "matId");
            return (Criteria) this;
        }

        public Criteria andMatIdNotEqualTo(Integer value) {
            addCriterion("mat_id <>", value, "matId");
            return (Criteria) this;
        }

        public Criteria andMatIdGreaterThan(Integer value) {
            addCriterion("mat_id >", value, "matId");
            return (Criteria) this;
        }

        public Criteria andMatIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("mat_id >=", value, "matId");
            return (Criteria) this;
        }

        public Criteria andMatIdLessThan(Integer value) {
            addCriterion("mat_id <", value, "matId");
            return (Criteria) this;
        }

        public Criteria andMatIdLessThanOrEqualTo(Integer value) {
            addCriterion("mat_id <=", value, "matId");
            return (Criteria) this;
        }

        public Criteria andMatIdIn(List<Integer> values) {
            addCriterion("mat_id in", values, "matId");
            return (Criteria) this;
        }

        public Criteria andMatIdNotIn(List<Integer> values) {
            addCriterion("mat_id not in", values, "matId");
            return (Criteria) this;
        }

        public Criteria andMatIdBetween(Integer value1, Integer value2) {
            addCriterion("mat_id between", value1, value2, "matId");
            return (Criteria) this;
        }

        public Criteria andMatIdNotBetween(Integer value1, Integer value2) {
            addCriterion("mat_id not between", value1, value2, "matId");
            return (Criteria) this;
        }

        public Criteria andMatCodeIsNull() {
            addCriterion("mat_code is null");
            return (Criteria) this;
        }

        public Criteria andMatCodeIsNotNull() {
            addCriterion("mat_code is not null");
            return (Criteria) this;
        }

        public Criteria andMatCodeEqualTo(String value) {
            addCriterion("mat_code =", value, "matCode");
            return (Criteria) this;
        }

        public Criteria andMatCodeNotEqualTo(String value) {
            addCriterion("mat_code <>", value, "matCode");
            return (Criteria) this;
        }

        public Criteria andMatCodeGreaterThan(String value) {
            addCriterion("mat_code >", value, "matCode");
            return (Criteria) this;
        }

        public Criteria andMatCodeGreaterThanOrEqualTo(String value) {
            addCriterion("mat_code >=", value, "matCode");
            return (Criteria) this;
        }

        public Criteria andMatCodeLessThan(String value) {
            addCriterion("mat_code <", value, "matCode");
            return (Criteria) this;
        }

        public Criteria andMatCodeLessThanOrEqualTo(String value) {
            addCriterion("mat_code <=", value, "matCode");
            return (Criteria) this;
        }

        public Criteria andMatCodeLike(String value) {
            addCriterion("mat_code like", value, "matCode");
            return (Criteria) this;
        }

        public Criteria andMatCodeNotLike(String value) {
            addCriterion("mat_code not like", value, "matCode");
            return (Criteria) this;
        }

        public Criteria andMatCodeIn(List<String> values) {
            addCriterion("mat_code in", values, "matCode");
            return (Criteria) this;
        }

        public Criteria andMatCodeNotIn(List<String> values) {
            addCriterion("mat_code not in", values, "matCode");
            return (Criteria) this;
        }

        public Criteria andMatCodeBetween(String value1, String value2) {
            addCriterion("mat_code between", value1, value2, "matCode");
            return (Criteria) this;
        }

        public Criteria andMatCodeNotBetween(String value1, String value2) {
            addCriterion("mat_code not between", value1, value2, "matCode");
            return (Criteria) this;
        }

        public Criteria andMatHeightIsNull() {
            addCriterion("mat_height is null");
            return (Criteria) this;
        }

        public Criteria andMatHeightIsNotNull() {
            addCriterion("mat_height is not null");
            return (Criteria) this;
        }

        public Criteria andMatHeightEqualTo(Double value) {
            addCriterion("mat_height =", value, "matHeight");
            return (Criteria) this;
        }

        public Criteria andMatHeightNotEqualTo(Double value) {
            addCriterion("mat_height <>", value, "matHeight");
            return (Criteria) this;
        }

        public Criteria andMatHeightGreaterThan(Double value) {
            addCriterion("mat_height >", value, "matHeight");
            return (Criteria) this;
        }

        public Criteria andMatHeightGreaterThanOrEqualTo(Double value) {
            addCriterion("mat_height >=", value, "matHeight");
            return (Criteria) this;
        }

        public Criteria andMatHeightLessThan(Double value) {
            addCriterion("mat_height <", value, "matHeight");
            return (Criteria) this;
        }

        public Criteria andMatHeightLessThanOrEqualTo(Double value) {
            addCriterion("mat_height <=", value, "matHeight");
            return (Criteria) this;
        }

        public Criteria andMatHeightIn(List<Double> values) {
            addCriterion("mat_height in", values, "matHeight");
            return (Criteria) this;
        }

        public Criteria andMatHeightNotIn(List<Double> values) {
            addCriterion("mat_height not in", values, "matHeight");
            return (Criteria) this;
        }

        public Criteria andMatHeightBetween(Double value1, Double value2) {
            addCriterion("mat_height between", value1, value2, "matHeight");
            return (Criteria) this;
        }

        public Criteria andMatHeightNotBetween(Double value1, Double value2) {
            addCriterion("mat_height not between", value1, value2, "matHeight");
            return (Criteria) this;
        }

        public Criteria andMatLengthIsNull() {
            addCriterion("mat_length is null");
            return (Criteria) this;
        }

        public Criteria andMatLengthIsNotNull() {
            addCriterion("mat_length is not null");
            return (Criteria) this;
        }

        public Criteria andMatLengthEqualTo(Double value) {
            addCriterion("mat_length =", value, "matLength");
            return (Criteria) this;
        }

        public Criteria andMatLengthNotEqualTo(Double value) {
            addCriterion("mat_length <>", value, "matLength");
            return (Criteria) this;
        }

        public Criteria andMatLengthGreaterThan(Double value) {
            addCriterion("mat_length >", value, "matLength");
            return (Criteria) this;
        }

        public Criteria andMatLengthGreaterThanOrEqualTo(Double value) {
            addCriterion("mat_length >=", value, "matLength");
            return (Criteria) this;
        }

        public Criteria andMatLengthLessThan(Double value) {
            addCriterion("mat_length <", value, "matLength");
            return (Criteria) this;
        }

        public Criteria andMatLengthLessThanOrEqualTo(Double value) {
            addCriterion("mat_length <=", value, "matLength");
            return (Criteria) this;
        }

        public Criteria andMatLengthIn(List<Double> values) {
            addCriterion("mat_length in", values, "matLength");
            return (Criteria) this;
        }

        public Criteria andMatLengthNotIn(List<Double> values) {
            addCriterion("mat_length not in", values, "matLength");
            return (Criteria) this;
        }

        public Criteria andMatLengthBetween(Double value1, Double value2) {
            addCriterion("mat_length between", value1, value2, "matLength");
            return (Criteria) this;
        }

        public Criteria andMatLengthNotBetween(Double value1, Double value2) {
            addCriterion("mat_length not between", value1, value2, "matLength");
            return (Criteria) this;
        }

        public Criteria andMatWidthIsNull() {
            addCriterion("mat_width is null");
            return (Criteria) this;
        }

        public Criteria andMatWidthIsNotNull() {
            addCriterion("mat_width is not null");
            return (Criteria) this;
        }

        public Criteria andMatWidthEqualTo(Double value) {
            addCriterion("mat_width =", value, "matWidth");
            return (Criteria) this;
        }

        public Criteria andMatWidthNotEqualTo(Double value) {
            addCriterion("mat_width <>", value, "matWidth");
            return (Criteria) this;
        }

        public Criteria andMatWidthGreaterThan(Double value) {
            addCriterion("mat_width >", value, "matWidth");
            return (Criteria) this;
        }

        public Criteria andMatWidthGreaterThanOrEqualTo(Double value) {
            addCriterion("mat_width >=", value, "matWidth");
            return (Criteria) this;
        }

        public Criteria andMatWidthLessThan(Double value) {
            addCriterion("mat_width <", value, "matWidth");
            return (Criteria) this;
        }

        public Criteria andMatWidthLessThanOrEqualTo(Double value) {
            addCriterion("mat_width <=", value, "matWidth");
            return (Criteria) this;
        }

        public Criteria andMatWidthIn(List<Double> values) {
            addCriterion("mat_width in", values, "matWidth");
            return (Criteria) this;
        }

        public Criteria andMatWidthNotIn(List<Double> values) {
            addCriterion("mat_width not in", values, "matWidth");
            return (Criteria) this;
        }

        public Criteria andMatWidthBetween(Double value1, Double value2) {
            addCriterion("mat_width between", value1, value2, "matWidth");
            return (Criteria) this;
        }

        public Criteria andMatWidthNotBetween(Double value1, Double value2) {
            addCriterion("mat_width not between", value1, value2, "matWidth");
            return (Criteria) this;
        }

        public Criteria andMatStatusIsNull() {
            addCriterion("mat_status is null");
            return (Criteria) this;
        }

        public Criteria andMatStatusIsNotNull() {
            addCriterion("mat_status is not null");
            return (Criteria) this;
        }

        public Criteria andMatStatusEqualTo(Integer value) {
            addCriterion("mat_status =", value, "matStatus");
            return (Criteria) this;
        }

        public Criteria andMatStatusNotEqualTo(Integer value) {
            addCriterion("mat_status <>", value, "matStatus");
            return (Criteria) this;
        }

        public Criteria andMatStatusGreaterThan(Integer value) {
            addCriterion("mat_status >", value, "matStatus");
            return (Criteria) this;
        }

        public Criteria andMatStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("mat_status >=", value, "matStatus");
            return (Criteria) this;
        }

        public Criteria andMatStatusLessThan(Integer value) {
            addCriterion("mat_status <", value, "matStatus");
            return (Criteria) this;
        }

        public Criteria andMatStatusLessThanOrEqualTo(Integer value) {
            addCriterion("mat_status <=", value, "matStatus");
            return (Criteria) this;
        }

        public Criteria andMatStatusIn(List<Integer> values) {
            addCriterion("mat_status in", values, "matStatus");
            return (Criteria) this;
        }

        public Criteria andMatStatusNotIn(List<Integer> values) {
            addCriterion("mat_status not in", values, "matStatus");
            return (Criteria) this;
        }

        public Criteria andMatStatusBetween(Integer value1, Integer value2) {
            addCriterion("mat_status between", value1, value2, "matStatus");
            return (Criteria) this;
        }

        public Criteria andMatStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("mat_status not between", value1, value2, "matStatus");
            return (Criteria) this;
        }

        public Criteria andMatNumUnitIsNull() {
            addCriterion("mat_num_unit is null");
            return (Criteria) this;
        }

        public Criteria andMatNumUnitIsNotNull() {
            addCriterion("mat_num_unit is not null");
            return (Criteria) this;
        }

        public Criteria andMatNumUnitEqualTo(String value) {
            addCriterion("mat_num_unit =", value, "matNumUnit");
            return (Criteria) this;
        }

        public Criteria andMatNumUnitNotEqualTo(String value) {
            addCriterion("mat_num_unit <>", value, "matNumUnit");
            return (Criteria) this;
        }

        public Criteria andMatNumUnitGreaterThan(String value) {
            addCriterion("mat_num_unit >", value, "matNumUnit");
            return (Criteria) this;
        }

        public Criteria andMatNumUnitGreaterThanOrEqualTo(String value) {
            addCriterion("mat_num_unit >=", value, "matNumUnit");
            return (Criteria) this;
        }

        public Criteria andMatNumUnitLessThan(String value) {
            addCriterion("mat_num_unit <", value, "matNumUnit");
            return (Criteria) this;
        }

        public Criteria andMatNumUnitLessThanOrEqualTo(String value) {
            addCriterion("mat_num_unit <=", value, "matNumUnit");
            return (Criteria) this;
        }

        public Criteria andMatNumUnitLike(String value) {
            addCriterion("mat_num_unit like", value, "matNumUnit");
            return (Criteria) this;
        }

        public Criteria andMatNumUnitNotLike(String value) {
            addCriterion("mat_num_unit not like", value, "matNumUnit");
            return (Criteria) this;
        }

        public Criteria andMatNumUnitIn(List<String> values) {
            addCriterion("mat_num_unit in", values, "matNumUnit");
            return (Criteria) this;
        }

        public Criteria andMatNumUnitNotIn(List<String> values) {
            addCriterion("mat_num_unit not in", values, "matNumUnit");
            return (Criteria) this;
        }

        public Criteria andMatNumUnitBetween(String value1, String value2) {
            addCriterion("mat_num_unit between", value1, value2, "matNumUnit");
            return (Criteria) this;
        }

        public Criteria andMatNumUnitNotBetween(String value1, String value2) {
            addCriterion("mat_num_unit not between", value1, value2, "matNumUnit");
            return (Criteria) this;
        }

        public Criteria andMatWeightUnitIsNull() {
            addCriterion("mat_weight_unit is null");
            return (Criteria) this;
        }

        public Criteria andMatWeightUnitIsNotNull() {
            addCriterion("mat_weight_unit is not null");
            return (Criteria) this;
        }

        public Criteria andMatWeightUnitEqualTo(String value) {
            addCriterion("mat_weight_unit =", value, "matWeightUnit");
            return (Criteria) this;
        }

        public Criteria andMatWeightUnitNotEqualTo(String value) {
            addCriterion("mat_weight_unit <>", value, "matWeightUnit");
            return (Criteria) this;
        }

        public Criteria andMatWeightUnitGreaterThan(String value) {
            addCriterion("mat_weight_unit >", value, "matWeightUnit");
            return (Criteria) this;
        }

        public Criteria andMatWeightUnitGreaterThanOrEqualTo(String value) {
            addCriterion("mat_weight_unit >=", value, "matWeightUnit");
            return (Criteria) this;
        }

        public Criteria andMatWeightUnitLessThan(String value) {
            addCriterion("mat_weight_unit <", value, "matWeightUnit");
            return (Criteria) this;
        }

        public Criteria andMatWeightUnitLessThanOrEqualTo(String value) {
            addCriterion("mat_weight_unit <=", value, "matWeightUnit");
            return (Criteria) this;
        }

        public Criteria andMatWeightUnitLike(String value) {
            addCriterion("mat_weight_unit like", value, "matWeightUnit");
            return (Criteria) this;
        }

        public Criteria andMatWeightUnitNotLike(String value) {
            addCriterion("mat_weight_unit not like", value, "matWeightUnit");
            return (Criteria) this;
        }

        public Criteria andMatWeightUnitIn(List<String> values) {
            addCriterion("mat_weight_unit in", values, "matWeightUnit");
            return (Criteria) this;
        }

        public Criteria andMatWeightUnitNotIn(List<String> values) {
            addCriterion("mat_weight_unit not in", values, "matWeightUnit");
            return (Criteria) this;
        }

        public Criteria andMatWeightUnitBetween(String value1, String value2) {
            addCriterion("mat_weight_unit between", value1, value2, "matWeightUnit");
            return (Criteria) this;
        }

        public Criteria andMatWeightUnitNotBetween(String value1, String value2) {
            addCriterion("mat_weight_unit not between", value1, value2, "matWeightUnit");
            return (Criteria) this;
        }

        public Criteria andMaterialKindIsNull() {
            addCriterion("material_kind is null");
            return (Criteria) this;
        }

        public Criteria andMaterialKindIsNotNull() {
            addCriterion("material_kind is not null");
            return (Criteria) this;
        }

        public Criteria andMaterialKindEqualTo(String value) {
            addCriterion("material_kind =", value, "materialKind");
            return (Criteria) this;
        }

        public Criteria andMaterialKindNotEqualTo(String value) {
            addCriterion("material_kind <>", value, "materialKind");
            return (Criteria) this;
        }

        public Criteria andMaterialKindGreaterThan(String value) {
            addCriterion("material_kind >", value, "materialKind");
            return (Criteria) this;
        }

        public Criteria andMaterialKindGreaterThanOrEqualTo(String value) {
            addCriterion("material_kind >=", value, "materialKind");
            return (Criteria) this;
        }

        public Criteria andMaterialKindLessThan(String value) {
            addCriterion("material_kind <", value, "materialKind");
            return (Criteria) this;
        }

        public Criteria andMaterialKindLessThanOrEqualTo(String value) {
            addCriterion("material_kind <=", value, "materialKind");
            return (Criteria) this;
        }

        public Criteria andMaterialKindLike(String value) {
            addCriterion("material_kind like", value, "materialKind");
            return (Criteria) this;
        }

        public Criteria andMaterialKindNotLike(String value) {
            addCriterion("material_kind not like", value, "materialKind");
            return (Criteria) this;
        }

        public Criteria andMaterialKindIn(List<String> values) {
            addCriterion("material_kind in", values, "materialKind");
            return (Criteria) this;
        }

        public Criteria andMaterialKindNotIn(List<String> values) {
            addCriterion("material_kind not in", values, "materialKind");
            return (Criteria) this;
        }

        public Criteria andMaterialKindBetween(String value1, String value2) {
            addCriterion("material_kind between", value1, value2, "materialKind");
            return (Criteria) this;
        }

        public Criteria andMaterialKindNotBetween(String value1, String value2) {
            addCriterion("material_kind not between", value1, value2, "materialKind");
            return (Criteria) this;
        }

        public Criteria andMatFormulaTypeIsNull() {
            addCriterion("mat_formula_type is null");
            return (Criteria) this;
        }

        public Criteria andMatFormulaTypeIsNotNull() {
            addCriterion("mat_formula_type is not null");
            return (Criteria) this;
        }

        public Criteria andMatFormulaTypeEqualTo(Integer value) {
            addCriterion("mat_formula_type =", value, "matFormulaType");
            return (Criteria) this;
        }

        public Criteria andMatFormulaTypeNotEqualTo(Integer value) {
            addCriterion("mat_formula_type <>", value, "matFormulaType");
            return (Criteria) this;
        }

        public Criteria andMatFormulaTypeGreaterThan(Integer value) {
            addCriterion("mat_formula_type >", value, "matFormulaType");
            return (Criteria) this;
        }

        public Criteria andMatFormulaTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("mat_formula_type >=", value, "matFormulaType");
            return (Criteria) this;
        }

        public Criteria andMatFormulaTypeLessThan(Integer value) {
            addCriterion("mat_formula_type <", value, "matFormulaType");
            return (Criteria) this;
        }

        public Criteria andMatFormulaTypeLessThanOrEqualTo(Integer value) {
            addCriterion("mat_formula_type <=", value, "matFormulaType");
            return (Criteria) this;
        }

        public Criteria andMatFormulaTypeIn(List<Integer> values) {
            addCriterion("mat_formula_type in", values, "matFormulaType");
            return (Criteria) this;
        }

        public Criteria andMatFormulaTypeNotIn(List<Integer> values) {
            addCriterion("mat_formula_type not in", values, "matFormulaType");
            return (Criteria) this;
        }

        public Criteria andMatFormulaTypeBetween(Integer value1, Integer value2) {
            addCriterion("mat_formula_type between", value1, value2, "matFormulaType");
            return (Criteria) this;
        }

        public Criteria andMatFormulaTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("mat_formula_type not between", value1, value2, "matFormulaType");
            return (Criteria) this;
        }

        public Criteria andMatQualityIdIsNull() {
            addCriterion("mat_quality_id is null");
            return (Criteria) this;
        }

        public Criteria andMatQualityIdIsNotNull() {
            addCriterion("mat_quality_id is not null");
            return (Criteria) this;
        }

        public Criteria andMatQualityIdEqualTo(Integer value) {
            addCriterion("mat_quality_id =", value, "matQualityId");
            return (Criteria) this;
        }

        public Criteria andMatQualityIdNotEqualTo(Integer value) {
            addCriterion("mat_quality_id <>", value, "matQualityId");
            return (Criteria) this;
        }

        public Criteria andMatQualityIdGreaterThan(Integer value) {
            addCriterion("mat_quality_id >", value, "matQualityId");
            return (Criteria) this;
        }

        public Criteria andMatQualityIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("mat_quality_id >=", value, "matQualityId");
            return (Criteria) this;
        }

        public Criteria andMatQualityIdLessThan(Integer value) {
            addCriterion("mat_quality_id <", value, "matQualityId");
            return (Criteria) this;
        }

        public Criteria andMatQualityIdLessThanOrEqualTo(Integer value) {
            addCriterion("mat_quality_id <=", value, "matQualityId");
            return (Criteria) this;
        }

        public Criteria andMatQualityIdIn(List<Integer> values) {
            addCriterion("mat_quality_id in", values, "matQualityId");
            return (Criteria) this;
        }

        public Criteria andMatQualityIdNotIn(List<Integer> values) {
            addCriterion("mat_quality_id not in", values, "matQualityId");
            return (Criteria) this;
        }

        public Criteria andMatQualityIdBetween(Integer value1, Integer value2) {
            addCriterion("mat_quality_id between", value1, value2, "matQualityId");
            return (Criteria) this;
        }

        public Criteria andMatQualityIdNotBetween(Integer value1, Integer value2) {
            addCriterion("mat_quality_id not between", value1, value2, "matQualityId");
            return (Criteria) this;
        }

        public Criteria andMatSpecIdIsNull() {
            addCriterion("mat_spec_id is null");
            return (Criteria) this;
        }

        public Criteria andMatSpecIdIsNotNull() {
            addCriterion("mat_spec_id is not null");
            return (Criteria) this;
        }

        public Criteria andMatSpecIdEqualTo(Integer value) {
            addCriterion("mat_spec_id =", value, "matSpecId");
            return (Criteria) this;
        }

        public Criteria andMatSpecIdNotEqualTo(Integer value) {
            addCriterion("mat_spec_id <>", value, "matSpecId");
            return (Criteria) this;
        }

        public Criteria andMatSpecIdGreaterThan(Integer value) {
            addCriterion("mat_spec_id >", value, "matSpecId");
            return (Criteria) this;
        }

        public Criteria andMatSpecIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("mat_spec_id >=", value, "matSpecId");
            return (Criteria) this;
        }

        public Criteria andMatSpecIdLessThan(Integer value) {
            addCriterion("mat_spec_id <", value, "matSpecId");
            return (Criteria) this;
        }

        public Criteria andMatSpecIdLessThanOrEqualTo(Integer value) {
            addCriterion("mat_spec_id <=", value, "matSpecId");
            return (Criteria) this;
        }

        public Criteria andMatSpecIdIn(List<Integer> values) {
            addCriterion("mat_spec_id in", values, "matSpecId");
            return (Criteria) this;
        }

        public Criteria andMatSpecIdNotIn(List<Integer> values) {
            addCriterion("mat_spec_id not in", values, "matSpecId");
            return (Criteria) this;
        }

        public Criteria andMatSpecIdBetween(Integer value1, Integer value2) {
            addCriterion("mat_spec_id between", value1, value2, "matSpecId");
            return (Criteria) this;
        }

        public Criteria andMatSpecIdNotBetween(Integer value1, Integer value2) {
            addCriterion("mat_spec_id not between", value1, value2, "matSpecId");
            return (Criteria) this;
        }

        public Criteria andMatTypeIdIsNull() {
            addCriterion("mat_type_id is null");
            return (Criteria) this;
        }

        public Criteria andMatTypeIdIsNotNull() {
            addCriterion("mat_type_id is not null");
            return (Criteria) this;
        }

        public Criteria andMatTypeIdEqualTo(Integer value) {
            addCriterion("mat_type_id =", value, "matTypeId");
            return (Criteria) this;
        }

        public Criteria andMatTypeIdNotEqualTo(Integer value) {
            addCriterion("mat_type_id <>", value, "matTypeId");
            return (Criteria) this;
        }

        public Criteria andMatTypeIdGreaterThan(Integer value) {
            addCriterion("mat_type_id >", value, "matTypeId");
            return (Criteria) this;
        }

        public Criteria andMatTypeIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("mat_type_id >=", value, "matTypeId");
            return (Criteria) this;
        }

        public Criteria andMatTypeIdLessThan(Integer value) {
            addCriterion("mat_type_id <", value, "matTypeId");
            return (Criteria) this;
        }

        public Criteria andMatTypeIdLessThanOrEqualTo(Integer value) {
            addCriterion("mat_type_id <=", value, "matTypeId");
            return (Criteria) this;
        }

        public Criteria andMatTypeIdIn(List<Integer> values) {
            addCriterion("mat_type_id in", values, "matTypeId");
            return (Criteria) this;
        }

        public Criteria andMatTypeIdNotIn(List<Integer> values) {
            addCriterion("mat_type_id not in", values, "matTypeId");
            return (Criteria) this;
        }

        public Criteria andMatTypeIdBetween(Integer value1, Integer value2) {
            addCriterion("mat_type_id between", value1, value2, "matTypeId");
            return (Criteria) this;
        }

        public Criteria andMatTypeIdNotBetween(Integer value1, Integer value2) {
            addCriterion("mat_type_id not between", value1, value2, "matTypeId");
            return (Criteria) this;
        }

        public Criteria andMatStockIdIsNull() {
            addCriterion("mat_stock_id is null");
            return (Criteria) this;
        }

        public Criteria andMatStockIdIsNotNull() {
            addCriterion("mat_stock_id is not null");
            return (Criteria) this;
        }

        public Criteria andMatStockIdEqualTo(Integer value) {
            addCriterion("mat_stock_id =", value, "matStockId");
            return (Criteria) this;
        }

        public Criteria andMatStockIdNotEqualTo(Integer value) {
            addCriterion("mat_stock_id <>", value, "matStockId");
            return (Criteria) this;
        }

        public Criteria andMatStockIdGreaterThan(Integer value) {
            addCriterion("mat_stock_id >", value, "matStockId");
            return (Criteria) this;
        }

        public Criteria andMatStockIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("mat_stock_id >=", value, "matStockId");
            return (Criteria) this;
        }

        public Criteria andMatStockIdLessThan(Integer value) {
            addCriterion("mat_stock_id <", value, "matStockId");
            return (Criteria) this;
        }

        public Criteria andMatStockIdLessThanOrEqualTo(Integer value) {
            addCriterion("mat_stock_id <=", value, "matStockId");
            return (Criteria) this;
        }

        public Criteria andMatStockIdIn(List<Integer> values) {
            addCriterion("mat_stock_id in", values, "matStockId");
            return (Criteria) this;
        }

        public Criteria andMatStockIdNotIn(List<Integer> values) {
            addCriterion("mat_stock_id not in", values, "matStockId");
            return (Criteria) this;
        }

        public Criteria andMatStockIdBetween(Integer value1, Integer value2) {
            addCriterion("mat_stock_id between", value1, value2, "matStockId");
            return (Criteria) this;
        }

        public Criteria andMatStockIdNotBetween(Integer value1, Integer value2) {
            addCriterion("mat_stock_id not between", value1, value2, "matStockId");
            return (Criteria) this;
        }

        public Criteria andMatNameDescIsNull() {
            addCriterion("mat_name_desc is null");
            return (Criteria) this;
        }

        public Criteria andMatNameDescIsNotNull() {
            addCriterion("mat_name_desc is not null");
            return (Criteria) this;
        }

        public Criteria andMatNameDescEqualTo(String value) {
            addCriterion("mat_name_desc =", value, "matNameDesc");
            return (Criteria) this;
        }

        public Criteria andMatNameDescNotEqualTo(String value) {
            addCriterion("mat_name_desc <>", value, "matNameDesc");
            return (Criteria) this;
        }

        public Criteria andMatNameDescGreaterThan(String value) {
            addCriterion("mat_name_desc >", value, "matNameDesc");
            return (Criteria) this;
        }

        public Criteria andMatNameDescGreaterThanOrEqualTo(String value) {
            addCriterion("mat_name_desc >=", value, "matNameDesc");
            return (Criteria) this;
        }

        public Criteria andMatNameDescLessThan(String value) {
            addCriterion("mat_name_desc <", value, "matNameDesc");
            return (Criteria) this;
        }

        public Criteria andMatNameDescLessThanOrEqualTo(String value) {
            addCriterion("mat_name_desc <=", value, "matNameDesc");
            return (Criteria) this;
        }

        public Criteria andMatNameDescLike(String value) {
            addCriterion("mat_name_desc like", value, "matNameDesc");
            return (Criteria) this;
        }

        public Criteria andMatNameDescNotLike(String value) {
            addCriterion("mat_name_desc not like", value, "matNameDesc");
            return (Criteria) this;
        }

        public Criteria andMatNameDescIn(List<String> values) {
            addCriterion("mat_name_desc in", values, "matNameDesc");
            return (Criteria) this;
        }

        public Criteria andMatNameDescNotIn(List<String> values) {
            addCriterion("mat_name_desc not in", values, "matNameDesc");
            return (Criteria) this;
        }

        public Criteria andMatNameDescBetween(String value1, String value2) {
            addCriterion("mat_name_desc between", value1, value2, "matNameDesc");
            return (Criteria) this;
        }

        public Criteria andMatNameDescNotBetween(String value1, String value2) {
            addCriterion("mat_name_desc not between", value1, value2, "matNameDesc");
            return (Criteria) this;
        }

        public Criteria andMatSapNameDescIsNull() {
            addCriterion("mat_sap_name_desc is null");
            return (Criteria) this;
        }

        public Criteria andMatSapNameDescIsNotNull() {
            addCriterion("mat_sap_name_desc is not null");
            return (Criteria) this;
        }

        public Criteria andMatSapNameDescEqualTo(String value) {
            addCriterion("mat_sap_name_desc =", value, "matSapNameDesc");
            return (Criteria) this;
        }

        public Criteria andMatSapNameDescNotEqualTo(String value) {
            addCriterion("mat_sap_name_desc <>", value, "matSapNameDesc");
            return (Criteria) this;
        }

        public Criteria andMatSapNameDescGreaterThan(String value) {
            addCriterion("mat_sap_name_desc >", value, "matSapNameDesc");
            return (Criteria) this;
        }

        public Criteria andMatSapNameDescGreaterThanOrEqualTo(String value) {
            addCriterion("mat_sap_name_desc >=", value, "matSapNameDesc");
            return (Criteria) this;
        }

        public Criteria andMatSapNameDescLessThan(String value) {
            addCriterion("mat_sap_name_desc <", value, "matSapNameDesc");
            return (Criteria) this;
        }

        public Criteria andMatSapNameDescLessThanOrEqualTo(String value) {
            addCriterion("mat_sap_name_desc <=", value, "matSapNameDesc");
            return (Criteria) this;
        }

        public Criteria andMatSapNameDescLike(String value) {
            addCriterion("mat_sap_name_desc like", value, "matSapNameDesc");
            return (Criteria) this;
        }

        public Criteria andMatSapNameDescNotLike(String value) {
            addCriterion("mat_sap_name_desc not like", value, "matSapNameDesc");
            return (Criteria) this;
        }

        public Criteria andMatSapNameDescIn(List<String> values) {
            addCriterion("mat_sap_name_desc in", values, "matSapNameDesc");
            return (Criteria) this;
        }

        public Criteria andMatSapNameDescNotIn(List<String> values) {
            addCriterion("mat_sap_name_desc not in", values, "matSapNameDesc");
            return (Criteria) this;
        }

        public Criteria andMatSapNameDescBetween(String value1, String value2) {
            addCriterion("mat_sap_name_desc between", value1, value2, "matSapNameDesc");
            return (Criteria) this;
        }

        public Criteria andMatSapNameDescNotBetween(String value1, String value2) {
            addCriterion("mat_sap_name_desc not between", value1, value2, "matSapNameDesc");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}